Entity Relationships - Employer Details (EMPLOYER)

Related Tables

Table Name	Table Description	Primary Keys	Usually Joins From	Join Type	Joins On	Details
EMPLOYER	Employer Details	EMPLOYERID				Stores basic details about each employer.
TREMPLOYER	Trainee-Employer Link	TRAINEEID, TREMPID	TRAINEE	One to many	TRAINEEID	Table which links trainees to employers.
EMPLOYERINFO	Employer Additional Info	EMPLOYERID	EMPLOYER	One to one	EMPLOYERID	Stores additional information about employers.
EMPLOYERSITE	Employer Branch Info	EMPLOYERID, SITEID, BRANCHID	EMPLOYER	One to one	EMPLOYERID, SITEID	Stores branch-specific information, such as branch address and contact details.
EMPASSESSOR	Employer-Assessor Link	ASSESSORID, EMPASSID	ASSESSOR or EMPLOYER	One to many	ASSESSORID or EMPLOYERID	Table which links assessors to employers.
VISITS	Visits / Diary	VISID	EMPLOYER *	One to many	EMPLOYERID	Stores visit information for employers, trainees and assessors. In this context, the table can join directly to the employer record.
TRMODULE	Trainee-Module Link	TRMODULEID, TRAINEEID	EMPLOYER	One to many	EMPLOYERID	Links trainees to objectives. In this context, an employer can be specified in TRMODULE to determine which of a trainee's modules are taking place at the employer.
EMPLOYERCOURSE	Employer-Course Link	EMPLOYERCOURSEID	EMPLOYER	One to many	EMPLOYERID	Links employers to courses.
EMPLOYERCONTACTS	Employer Contacts	CONTACTID	EMPLOYER	One to many	EMPLOYERID	Stores contact personnel details for employers.
EMPGENERALEVENTS	Employer General Events	EMPLOYERID, EVENTID	EMPLOYER	One to many	EMPLOYERID	Links employers to general events.

* Note on VISITS - The VISITS table stores visits for assessors, trainees and employers, and can join directly to the ASSESSOR, TRAINEE and EMPLOYER tables. In this context, the direct link between EMPLOYER and VISITS is effectively the employer diary. It is also possible to join in a different way via trainees to see the visits associated with the trainees at an employer: